| This sample shows how Access2Web handles Excel sheets. Notice that the loop starts at record 3, thereby ignoring the first 3 rows in the Excel sheet. This
is often useful when dealing with Excel sheets.
Also the region is formatted to uppercase, thus showing "US" and not "us". |
|||||
| Name | SSN | Position | Region | Department | Manager |
| Bill Lee | 111-111-1111 | Sales | US | Sales | Shannon MacArthur |
| Shannon MacArthur | 222-222-2222 | Management | US | Management | Melinda Overmire |
| Melinda Overmire | 333-333-3333 | Owner | US | Management | |
| Wayne McBride | 444-444-4444 | Management | US | Management | Melinda Overmire |
| Greg Andersen | 555-555-5555 | Sales | US | Sales | Shannon MacArthur |
| Hugh Mickelson | 666-666-6666 | Sales | US | Sales | Shannon MacArthur |
| Phil Price | 777-777-7777 | Sales | US | Sales | Shannon MacArthur |
| Peter Lehman | 888-888-8888 | Management | US | Management | Melinda Overmire |